package com.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.pojo.MovieList;
import com.pojo.SpecialFilmList;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SpecialFilmListDAO extends BaseMapper<SpecialFilmList> {

    IPage getSpecialFilmByTypeId(Page p,  int id);


    @Select("select * from movie_list join specialfilmlist on movie_list.id=specialfilmlist.movie_id join special on special.id=specialfilmlist.special_id")
    List<MovieList> getAllFilm();
}
